﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/
USE [LYWebsite]
GO

INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('义乌'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('杭州'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('上海'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('南京'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('芜湖'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('合肥'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('徐州'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('济南'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('石家庄'
		   ,''
           ,'')
INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('天津'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('北京'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('莫斯科'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('柏林'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('巴黎'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('伦敦'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('好望角'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('巴西利亚'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('纽约'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('悉尼'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('三沙'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('酒泉'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('月球'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('火星'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('冲出银河系'
           ,''
           ,'')
		   INSERT INTO [dbo].[Location]
           ([LocationName]
           ,[ImageUrl]
           ,[Description])
     VALUES
           ('冲出宇宙'
           ,''
           ,'')
 

INSERT INTO [dbo].[Car]
           ([CarName]
           ,[Battery]
           ,[Description]
           ,[ImageUrl])
     VALUES
           ('飞扬'
           ,10
           ,'型号：JK-4R4812L-Z1'
           ,'')
		   INSERT INTO [dbo].[Car]
           ([CarName]
           ,[Battery]
           ,[Description]
           ,[ImageUrl])
     VALUES
           ('欧尚'
           ,20
           ,'型号：MQE-CS6020-G2'
           ,'')
		   INSERT INTO [dbo].[Car]
           ([CarName]
           ,[Battery]
           ,[Description]
           ,[ImageUrl])
     VALUES
           ('凯宝2'
           ,12
           ,'型号：HKM2-5T4812-D1'
           ,'')
		   INSERT INTO [dbo].[Car]
           ([CarName]
           ,[Battery]
           ,[Description]
           ,[ImageUrl])
     VALUES
           ('云裳'
           ,20
           ,'型号：HQC-5T4820-G2'
           ,'')
GO


